Even though the ORDER BY clause supports using column numbers, doing so makes the code difficult to read and maintain. Therefore the
use of column names is preferred.
Noncompliant code example
SELECT FIRST_NAME, LAST_NAME, REGION
FROM PERSONS
ORDER BY 2, 1
Compliant solution
SELECT FIRST_NAME, LAST_NAME, REGION
FROM PERSONS
ORDER BY LAST_NAME, FIRST_NAME
